
{get sql="SELECT * FROM `dc_area` WHERE LENGTH(areacode)=2" rows="100" return="a"}
    <h2 style="color:red;">{$a[areaname]}</h2>
    {get sql="SELECT * FROM `dc_area` WHERE `areacode` LIKE '$a[areacode]%' AND `areacode`!='$a[areacode]' AND LENGTH(areacode)=4 "rows="100" return="b"}
        <div style="margin-left:50px;">
        <p style="color:blue;font-weight:800;">{$b[areaname]}</p>
        {get sql="SELECT * FROM `dc_area` WHERE `areacode` LIKE '$b[areacode]%' AND `areacode`!='$b[areacode]' AND LENGTH(areacode)=6" rows="100" return="c"}
            <span>{$c[areaname]}</span> 
        {/get}
        </div>
    {/get}
{/get}
